1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10
11 namespace SoftQuanLyNhaHang.Views
12 {
13 public delegate void LinkKiemTraKho_ShowForm_EventHandler(object sender, EventArgs e);
14
15 public delegate void LinkKiemTraKho_ChiTiet_EventHandler(object sender, EventArgs e, int idKiemKho);
16
17 public partial class uctKho_KiemTraKho_List : UserControl
18 {
19 public uctKho_KiemTraKho_List()
20 {
21 InitializeComponent();
22 }
23
24 //Khởi tạo gọi menu
25 public static uctKho_KiemTraKho_List uctK_ktk_List = new uctKho_KiemTraKho_List();
26
27 public event LinkKiemTraKho_ShowForm_EventHandler Link_KiemTraKho_ShowForm;
28
29 public event LinkKiemTraKho_ChiTiet_EventHandler Link_KiemKho_ChiTiet;
30
31 int _IdKho_KiemKho = 0;
32 string _TrangThai = "SuDung";
33 float _TongSoMatHangTrongKho = 0;
34 float _TongSoMatHangKiemKho = 0;
35 string _DienGiai = string.Empty;
36 DateTime _NgayKiemKho = DateTime.Now;
37 int _pageSize = 30;
38 int _pageIndex = 1;
39 int _stt = 0;
40 int _tongSoBanGhi;
41
42 private void uctKho_KiemTraKho_List_Load(object sender, EventArgs e)
43 {
44 this.HienThiDanhSachKiemKho();
45 }
46
47 //hien thi danh sach kiem kho
48 private void HienThiDanhSachKiemKho()
49 {
50 dgvDsKiemKho.Rows.Clear();
51 //Ẩn cột đầu tiên
52 dgvDsKiemKho.RowHeadersVisible = false;
53 //-https://stackoverflow.com/questions/17404969/right-align-a-column-in-datagridview-doesnt-work
54 this.dgvDsKiemKho.Columns["STT"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
55 this.dgvDsKiemKho.Columns["STT"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
56 //this.dgvDsKiemKho.Columns["STT"].SortMode = DataGridViewColumnSortMode.NotSortable;
57
58 this.dgvDsKiemKho.Columns["IdKho_KiemKho"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
59 this.dgvDsKiemKho.Columns["IdKho_KiemKho"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
60
61 this.dgvDsKiemKho.Columns["NgayBatDau"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
62 this.dgvDsKiemKho.Columns["NgayBatDau"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
63
64 this.dgvDsKiemKho.Columns["NgayKetThuc"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
65 this.dgvDsKiemKho.Columns["NgayKetThuc"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
66
67
68 this.dgvDsKiemKho.Columns["TongSoMatHangTrongKho"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
69 this.dgvDsKiemKho.Columns["TongSoMatHangTrongKho"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
70
71 this.dgvDsKiemKho.Columns["SoMatHangKiemKho"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
72 this.dgvDsKiemKho.Columns["SoMatHangKiemKho"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
73
74 this.dgvDsKiemKho.Columns["SoLuongChenhLech"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
75 this.dgvDsKiemKho.Columns["SoLuongChenhLech"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
76
77
78 DataTable dtKk = new DataTable();
79 dtKk = Controllers.Kho_KiemKhoCtrl.FillDataSet_getKho_KiemKho_Search(_IdKho_KiemKho, _TrangThai, _TongSoMatHangTrongKho, _TongSoMatHangKiemKho, _DienGiai, _NgayKiemKho, _pageSize, _pageIndex).Tables[0];
80 if (dtKk.Rows.Count > 0)
81 {
82
83 _tongSoBanGhi = Int32.Parse(dtKk.Rows[0]["TongSoBanGhi"].ToString());
84
85 double tongMatHangTrongKho = 0;
86 double tongMatHangKiemKho = 0;
87 double SoLuongChenLech = 0;
88 foreach (DataRow item in dtKk.Rows)
89 {
90 _stt += 1;
91 int n = dgvDsKiemKho.Rows.Add();
92
93 dgvDsKiemKho.Rows[n].Cells["IdKho_KiemKho"].Value = item["IdKho_KiemKho"].ToString();
94 dgvDsKiemKho.Rows[n].Cells["STT"].Value = _stt.ToString();
95
96 dgvDsKiemKho.Rows[n].Cells["NgayBatDau"].Value = CauHinhHeThong.Format_HienThiNgayThangNam(item["NgayKiemKho"].ToString(), true);
97 //dgvDsKiemKho.Rows[n].Cells["NgayKetThuc"].Value = CauHinhHeThong.Format_HienThiNgayThangNam(item["NgayKetThuc"].ToString(), true);
98
99 tongMatHangTrongKho = CauHinhHeThong.Format_SoDeTinhToan(item["TongSoMatHangTrongKho"].ToString(), false);
100 dgvDsKiemKho.Rows[n].Cells["TongSoMatHangTrongKho"].Value = CauHinhHeThong.Format_SoDeHienThi(tongMatHangTrongKho, false);
101
102 tongMatHangKiemKho = CauHinhHeThong.Format_SoDeTinhToan(item["SoMatHangKiemKho"].ToString(), false);
103 dgvDsKiemKho.Rows[n].Cells["SoMatHangKiemKho"].Value = CauHinhHeThong.Format_SoDeHienThi(tongMatHangKiemKho, false);
104
105 SoLuongChenLech = tongMatHangKiemKho - tongMatHangTrongKho;
106
107 dgvDsKiemKho.Rows[n].Cells["SoLuongChenhLech"].Value = CauHinhHeThong.Format_SoDeHienThi(SoLuongChenLech, false);
108
109 dgvDsKiemKho.Rows[n].Cells["Chon"].Value = "Chi tiết";
110
111
112 }
113 }
114 else
115 {
116 _tongSoBanGhi = 0;
117 }
118
119 lblTongSoBanGhiHienThi.Text = CauHinhHeThong.HienThiSoBanGhiTuA_DenB(_pageSize, _pageIndex, _stt.ToString(), _tongSoBanGhi.ToString());
120
121 }
122
123 private void linkLabelKiemTraKho_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
124 {
125 if (this.Link_KiemTraKho_ShowForm != null)
126 {
127 this.Link_KiemTraKho_ShowForm(sender, e);
128 }
129 }
130
131 private void btnTiep_Click(object sender, EventArgs e)
132 {
133
134 }
135
136 private void btnSau_Click(object sender, EventArgs e)
137 {
138
139 }
140
141 private void dgvDsKiemKho_CellClick(object sender, DataGridViewCellEventArgs e)
142 {
143 if ((dgvDsKiemKho.Columns[e.ColumnIndex].Name == "Chon") && e.RowIndex != -1)
144 {
145 //-https://stackoverflow.com/questions/12762036/datagridview-cell-click-event
146 if (dgvDsKiemKho.CurrentCell != null && dgvDsKiemKho.CurrentCell.Value != null)
147 {
148 int idKiemKho = Int32.Parse(dgvDsKiemKho.Rows[e.RowIndex].Cells["IdKho_KiemKho"].Value.ToString());
149
150 if (this.Link_KiemKho_ChiTiet != null)
151 {
152 this.Link_KiemKho_ChiTiet(sender, e, idKiemKho);
153 }
154 }
155
156 }
157
158 }
159 }
160 }